CREATE TABLE jms_dim.dim_tab_province_category_config_base(
  `id` varchar(100) COMMENT '主键ID',
  `province_id` varchar(50) COMMENT '省份编号',
  `province` varchar(100) COMMENT '省份',
  `city_id` varchar(50) COMMENT '城市编号',
  `city_name` varchar(100) COMMENT '城市',
  `category` varchar(50) COMMENT '类别：一类 二类 三类  四类 五类  六类'
)
ENGINE = OLAP
DUPLICATE KEY(`id`)
COMMENT '省份类别配置表'
DISTRIBUTED BY HASH(`id`) BUCKETS 1
PROPERTIES (
   "replication_num" = "3",
   "in_memory" = "true",
   "storage_format" = "V2"
);